Round 1 - Technical - SQL

🔹Introduction

🔹Project Discussion

🔹SQL Question - Output for all window functions for given dataset.

🔹SQL Question - Output for all joined for data set involves 0,0,1 null like this.

🔹SQL Question - It was medium level involved case when statement.

Round 2 - Technical - Resume and SQL

🔹Introduction

🔹Project discussion.

🔹Resume discussion and it was like a stress round as interview tested the power of taking stress as It was like he asked line by line things written in the resume. But at the end he made me comfortable by saying nothing just I was testing your stress taking ability.

🔹SQL Question - It was a difficult question based upon cross join. Interviewer helped me to solve this.

After this I received call from HR that I have cleared the interview, and FIT round will be scheduled but later vacancy went on hold.